In [1]:
import pandas as pd
import numpy as np
In [72]:
state_data_filepath = '.\\Data\\State\\DaysOnZillow_Public_State.csv'
state_days_on_zillow = pd.read_csv(state_data_filepath)
state_days_on_zillow.head()
Out[72]:
In [73]:
state_days_on_zillow__limited = state_days_on_zillow[[col for col in state_days_on_zillow.axes[1] if ((col >= '2011-01' and col <= '2016-01') or (col == 'RegionName'))]]
state_days_on_zillow__limited = state_days_on_zillow__limited.set_index(['RegionName'])
state_days_on_zillow__limited.head()
Out[73]:
In [98]:
test = pd.DataFrame(state_days_on_zillow__limited[['2011-01']], index=[state_days_on_zillow__limited.axes[0]])
test['Period'] = pd.Series({state:'2011-01' for state in state_days_on_zillow__limited.axes[0]})
test = test.set_index('Period', append=True).rename_axis({'2011-01':'var_name'}, axis='columns')
test2 = pd.DataFrame(state_days_on_zillow__limited[['2011-02']], index=[state_days_on_zillow__limited.axes[0]])
test2['Period'] = pd.Series({state:'2011-02' for state in state_days_on_zillow__limited.axes[0]})
test2 = test2.set_index('Period', append=True).rename_axis({'2011-02':'var_name'}, axis='columns')
test.append(test2)
Out[98]:
In [108]:
state_days_on_zillow_flat = pd.DataFrame(state_days_on_zillow__limited[['2011-01']], index=[state_days_on_zillow__limited.axes[0]])
state_days_on_zillow_flat['Period'] = pd.Series({state:'2011-01' for state in state_days_on_zillow__limited.axes[0]})
state_days_on_zillow_flat = state_days_on_zillow_flat.set_index('Period', append=True).rename_axis({'2011-01':'days_on_zillow'}, axis='columns')
for col_name in state_days_on_zillow__limited.axes[1][1:]:
temp = pd.DataFrame(state_days_on_zillow__limited[[col_name]], index=[state_days_on_zillow__limited.axes[0]])
temp['Period'] = pd.Series({state:col_name for state in state_days_on_zillow__limited.axes[0]})
temp = temp.set_index('Period', append=True).rename_axis({col_name:'days_on_zillow'}, axis='columns')
state_days_on_zillow_flat = state_days_on_zillow_flat.append(temp)
state_days_on_zillow_flat
Out[108]:
In [110]:
export_path = '.\\Data\\Processed Data\\State - Days on Zillow.csv'
state_days_on_zillow_flat.to_csv(export_path)